package com.sky.mapper.user;

import com.sky.pojo.Category;
import com.sky.pojo.DishFlavor;
import com.sky.pojo.Setmeal;
import com.sky.vo.DishItemVO;
import com.sky.vo.DishVO;
import com.sky.vo.SetmealVO;
import org.apache.ibatis.annotations.Select;

import java.util.List;

public interface UserDishMapper {
    @Select("select * from category")
    List<Category> selectAllCategory();


    List<DishVO> selectDishByCategoryId(Integer categoryId);

    @Select("Select * from Setmeal where category_id = #{categoryId}")
    List<SetmealVO> selectSetmealVOByCategoryId(Setmeal setmeal);

    @Select("select name,copies,image ,description from Setmeal where setmeal_id = #{setmealId}")
    List<DishItemVO> selectDishFromSetmeal(Long setmealId);

    @Select("select * from dish_flavor where dish_id = #{id} ")
    List<DishFlavor> selectDishFlavorbyCategoryId(Long id);


    List<DishFlavor> selectDishFlavorbyCategoryIds(List<Long> dishIds);


}
